<%@ page language="java" contentType="text/html; charset=BIG5"
    pageEncoding="BIG5"%>
<%@page import="Annotation.DataBase.*"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=BIG5">
<title>Insert title here</title>
</head>

<%
String studentnumber = request.getParameter("studentnumber");
String studentname = request.getParameter("studentname");
String studentID = request.getParameter("studentID");
String courseID = request.getParameter("CourseID");
%>


<body>

<%
MySQLCommand ss= new MySQLCommand();


String sql="UPDATE student_info SET student_number='"+studentnumber+"', student_name='"+studentname+"' WHERE PK_student_info="+studentID+";";
ss.executeSQL(sql);
//out.print("<script>alert('adding school name is succeful!');</script>");

out.println(courseID);

response.sendRedirect("manageCourseStudent1_chooseCourse.jsp");


%>






</body>
</html>